const connection = require('../app/database')

class LabelService{
  async create(name){
    const statement = `
      INSERT INTO label (name) VALUES (?);
    `
    const [result] = await connection.execute(statement,[name])
    return result
  }
  
  async getLabelName(name){
    const statement = `
      SELECT * FROM label WHERE name = ?;
    `
    const [result] = await connection.execute(statement,[name])
    return result[0]
  }

  async getLabelList(limit,page){
    const statement = `
      SELECT * FROM label LIMIT ?,?;
    `
    const [result] = await connection.execute(statement,[(page-1)*limit,limit])
    return result
  }
}

module.exports = new LabelService()